UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T6fHC0gHdycNpE+kh4aMu22zr/XD5cp24kvsbp7sN9s='
WHERE
key_id = 'f4f1144d2c9245c8f67ae396901c4a43cea3ead1452825cf9fdae806f27dba1c'
AND (
token = 'T6fHC0gHdycNpE+kh4aMu22zr/XD5cp24kvsbp7sN9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)