UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNzM5jmNmSp6evKfoazlwxEOicCHjobh4lKrT2cXJw8='
WHERE
key_id = '8a8004c953b3ed759c012b29b9d3473ce8f3ad9199eb65ba1d526b2e537a736b'
AND (
token = 'fNzM5jmNmSp6evKfoazlwxEOicCHjobh4lKrT2cXJw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)