UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1cB85jMfdK5qSF3VRlMmvf/OmmUb27hWQcoP2pc98Y='
WHERE
key_id = '78fd3e1455bbaf9edd2ecb2d957dbfd8ad2f93cb9e20aef5e1b2a22e325c95f8'
AND (
token = 'W1cB85jMfdK5qSF3VRlMmvf/OmmUb27hWQcoP2pc98Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)