UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k6+PKFu0z3eYhDZlEgkHljhPkhWU+liQIqZHjk4G75I='
WHERE
key_id = '02b95e8fac176ea62e283067d1aace5bbe019dc7b97b731755263b94f3ebbe13'
AND (
token = 'k6+PKFu0z3eYhDZlEgkHljhPkhWU+liQIqZHjk4G75I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)