UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IxnR+/IN26X3Qy9+U+5DGfLuBcmDpP1/e7B3s8YOalU='
WHERE
key_id = 'e9bb86f2907228dbc6db488dc6c8642333f62eefdeea11087f7aa8557c279207'
AND (
token = 'IxnR+/IN26X3Qy9+U+5DGfLuBcmDpP1/e7B3s8YOalU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)