UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SYhlt3TAVukv44qIzEmlPO4SHEmuWn3hdB09YjJkA/I='
WHERE
key_id = '9a1bd5e85c1735b558331b7b3eb240886703b96b31445f9acbbb5527f3ce19f7'
AND (
token = 'SYhlt3TAVukv44qIzEmlPO4SHEmuWn3hdB09YjJkA/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)