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