UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gKeUUmKkNCjXXXMLvUTvvJrr17/G5fc6jGNm2q1AODU='
WHERE
key_id = 'fcde5a9bed8b50901e62b8642b34664542d0a84fef353b48971c6e3eb0e33080'
AND (
token = 'gKeUUmKkNCjXXXMLvUTvvJrr17/G5fc6jGNm2q1AODU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)