UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2QFZqzdofVJ6PfyeXARRNAZua8WKdygogLKhz3BNwwU='
WHERE
key_id = 'ca9cfeb2e039f2099cd2c74d0738c5328efda32681b9f3c45c29c225d67cc868'
AND (
token = '2QFZqzdofVJ6PfyeXARRNAZua8WKdygogLKhz3BNwwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)