UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tibwbqzAD1Z5CfnyVOZCEVwJ2Bo8Kc6IEoc13AIUPi0='
WHERE
key_id = 'd4cd9d7037852469179064f3abf2794c28e4b6871030ebe8145004fec06ffb3d'
AND (
token = 'tibwbqzAD1Z5CfnyVOZCEVwJ2Bo8Kc6IEoc13AIUPi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)