UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0tsgN0gsoqWPh4YlnFWLX5dO3855uhsh5qGTkgYhI8='
WHERE
key_id = '9b05fd21397a789b8a91001524cf400b68bb14dc86718e6b6571d3bc4f130b83'
AND (
token = 'X0tsgN0gsoqWPh4YlnFWLX5dO3855uhsh5qGTkgYhI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)