UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4koXLoJBnbaEgisl1VLLKkxvIWh7mBnOZHqfmbM7hps='
WHERE
key_id = 'd1a3fdb91855b0e1537ff0d9cbb1e0b0c3db41933e7b56388f02128eb086a0fd'
AND (
token = '4koXLoJBnbaEgisl1VLLKkxvIWh7mBnOZHqfmbM7hps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)