UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Be86cKA/KJd1gtj6YeD+3diTN9Tf2PD94sre23vy2Eg='
WHERE
key_id = '916db4d5c22fb9b6bb8a88948d91ce07dd894e4897a363b4d72955f95a643506'
AND (
token = 'Be86cKA/KJd1gtj6YeD+3diTN9Tf2PD94sre23vy2Eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)