UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CSW5gZeHsknD1BRDUlwqMy0b1aNI253l5QTeU7eU7UY='
WHERE
key_id = '6d0ac97d3be2067e08f85ec395a057cd4dc05731a1d079945ee693cf81b17356'
AND (
token = 'CSW5gZeHsknD1BRDUlwqMy0b1aNI253l5QTeU7eU7UY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)