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