UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dFtQpbGkHfEMqmA5pEdhaqIAZBNXDMazEwX0JfAoXT4='
WHERE
key_id = '0c9432216b8ba2e72ad09b76521ccf2ede8221144658c3a982fa55129b468b48'
AND (
token = 'dFtQpbGkHfEMqmA5pEdhaqIAZBNXDMazEwX0JfAoXT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)