UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pbtFSQOBHPppJrG5tGV0p3ACp9+yT6gKgpb+WAC78b4='
WHERE
key_id = 'c51c4b9464e28cfe93143bdf81d68a49699a420412cb731aeb88f4a3e69399ef'
AND (
token = 'pbtFSQOBHPppJrG5tGV0p3ACp9+yT6gKgpb+WAC78b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)