UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NixNzO/8SYxoHtYmLDLhpzbTBad4yprlp5FX5D6qv0s='
WHERE
key_id = 'c120b92079c2dddc28299db40cd16afe9fef6ed2e6f26c58b7a872f7110f6bca'
AND (
token = 'NixNzO/8SYxoHtYmLDLhpzbTBad4yprlp5FX5D6qv0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)