UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jVxBzy7i/uuA+ZzdvAwn9TTF3OJQ05+8v6K4YpzxHH4='
WHERE
key_id = '1b504dd89f730b8959ff661c31a82790f5c9ef2cf36353aee53a0f37fca0c855'
AND (
token = 'jVxBzy7i/uuA+ZzdvAwn9TTF3OJQ05+8v6K4YpzxHH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)