UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpqwbGW7MP+yqmv0vuEYNu4N6+LtQFE8lX88stsozFQ='
WHERE
key_id = 'c78f298bd49f389b010093059460f432ea24b764d2072969fe9f6bf46700b569'
AND (
token = 'tpqwbGW7MP+yqmv0vuEYNu4N6+LtQFE8lX88stsozFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)