UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NjczyUhkhFIBT1W2EpJ0lihTgvR/g7HkuBvfIc2CEA='
WHERE
key_id = 'ca9f75b435b4fe2392d6a717df0bfe2388e37a29e9b93b15fa9000433b9d5474'
AND (
token = '6NjczyUhkhFIBT1W2EpJ0lihTgvR/g7HkuBvfIc2CEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)