UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK4BtDyqXNf8sHwfUTg0sby0QneuQrFr6TdIXnQC+oc='
WHERE
key_id = 'b0ce7e15fc6d7a2f101068e35c08eb19be380f92a54c06b6daf4d06e0b2c98cb'
AND (
token = 'zK4BtDyqXNf8sHwfUTg0sby0QneuQrFr6TdIXnQC+oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)