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