UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7VrUpEVKgWKtjnUZ7Wb25w2Qssnv0W2sLnAPen7bKUE='
WHERE
key_id = 'a97e94b0bed02dfa62f5a4ab858fbe66d4b9359e3abded467927af3922bc0155'
AND (
token = '7VrUpEVKgWKtjnUZ7Wb25w2Qssnv0W2sLnAPen7bKUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)