UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WhpVAbVDRYZrjgiHX4z8d06Xvkl9Ic0p+hpew9YdxRY='
WHERE
key_id = '418cb21f6ad4acc380ef92d68ad2e93a1a36a7abacb36e9059f6f32761a88e1c'
AND (
token = 'WhpVAbVDRYZrjgiHX4z8d06Xvkl9Ic0p+hpew9YdxRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)