UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kp5IxfEYg5s4iRftBf8IL7801DlOrDqwWbj2ZFiP7mU='
WHERE
key_id = '3fcde2c7d4098cdc52b295759c57fc3888a165b3f9e7551406b46dae1ffb6832'
AND (
token = 'Kp5IxfEYg5s4iRftBf8IL7801DlOrDqwWbj2ZFiP7mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)