UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ePNaKA8qJ2J+h0bGnmYWP7PMEbsSedVnO2AMqT16+hU='
WHERE
key_id = 'd6352ef9b827f1b928924fbf5ba3136846621388afbf53bfde08296ac07f9a6c'
AND (
token = 'ePNaKA8qJ2J+h0bGnmYWP7PMEbsSedVnO2AMqT16+hU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)