UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9JUCrhuC0dFE6SRHyTgqTSM3Lrd2mxh1wL/hHjgqxA='
WHERE
key_id = '3a48b06253e44d97b416945f197dba9fb789765dcb1a8b2648213a2b68fb8743'
AND (
token = 'b9JUCrhuC0dFE6SRHyTgqTSM3Lrd2mxh1wL/hHjgqxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)