UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'peaukJklkhMCVlQx/VNBirF39ZzWkj6Gi5dJWW1KKhE='
WHERE
key_id = 'c7ffdd843c1694b45c43cce1b1b4b4911c69a33e663f24db27ec8b059bc5c3e8'
AND (
token = 'peaukJklkhMCVlQx/VNBirF39ZzWkj6Gi5dJWW1KKhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)