UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HtlBWCIW65ba9VZclpKZtSzdfmRWcqraxVodqXjpG8M='
WHERE
key_id = 'eae5b0a9c430e35e8ce28f32a67ae0012e61ff0ffbe1f701518a2d5306d4b0df'
AND (
token = 'HtlBWCIW65ba9VZclpKZtSzdfmRWcqraxVodqXjpG8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)