UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JsES3HAPKyf1mF6WGt2qFTPgvaXvMMN55pvoubJ+hCU='
WHERE
key_id = '99132fc459dedc1200532c9b47ef1e0cc53740fa44223de3ae1242ac70937bea'
AND (
token = 'JsES3HAPKyf1mF6WGt2qFTPgvaXvMMN55pvoubJ+hCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)