UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tV6X1RUiH9HEG3x+1P/1b0fpcIsgDz7tsF0ThekS3D8='
WHERE
key_id = '1142fefad8f22339a16d53f296333a099e96d0fb8570e3b55dbc9181f6c414a3'
AND (
token = 'tV6X1RUiH9HEG3x+1P/1b0fpcIsgDz7tsF0ThekS3D8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)