UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZAMHhE9iOZZPA74Zf/z3YvXNXmOfdwTHOnM1D/+WZw='
WHERE
key_id = '27517631125f14503c1b3b179f39a42ee5390a1597518339b98583707b03a38c'
AND (
token = '7ZAMHhE9iOZZPA74Zf/z3YvXNXmOfdwTHOnM1D/+WZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)