UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XCg+jUU5wy9k887+ICNhB6RC6i8pd4XEi5Oi9AhYvaA='
WHERE
key_id = 'bfb8b4424cb123d82309a0910b78fe8c5f065c99dc6b8eb07648152f70f9e011'
AND (
token = 'XCg+jUU5wy9k887+ICNhB6RC6i8pd4XEi5Oi9AhYvaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)