UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoP5Vb3A1oERMj8VbwHUjsRvLja5QM4ExBx3E+XaHls='
WHERE
key_id = 'b787c38393cdbf2abcea79ca1c02ebbbf566b1f64efe47bedb79ba908bb8c65e'
AND (
token = 'RoP5Vb3A1oERMj8VbwHUjsRvLja5QM4ExBx3E+XaHls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)