UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p5JzvMTOtgn64lZ49c5OKktMIg9Coy3rsCKxPq7w4qg='
WHERE
key_id = '70aee221e514e2eacddf6e1ff8878684a8fe0105c270b507297a4365d86f82a8'
AND (
token = 'p5JzvMTOtgn64lZ49c5OKktMIg9Coy3rsCKxPq7w4qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)