UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwU514PO9bYOFLojR2C3GmujhpGHBoXtN6pqB2wagKM='
WHERE
key_id = '785f92c82457fe3a25e08890c6e12c63e2341f262ce221a8e25925d0e1301f77'
AND (
token = 'XwU514PO9bYOFLojR2C3GmujhpGHBoXtN6pqB2wagKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)