UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8VO/QkRzK8oBlvTL/73xfMYqTSZCy8bMp8FbtZPJmyU='
WHERE
key_id = '565fa64bc7198c1395a52074f96abe15d01395509ff051fb514bf8e25e5dcb7a'
AND (
token = '8VO/QkRzK8oBlvTL/73xfMYqTSZCy8bMp8FbtZPJmyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)