UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C+h0Zkx0aJMpbASrElqZkvpE+GJHBl7xNAsY8Lpip78='
WHERE
key_id = 'a2cf1f82949f96989cbb58a0afdd3307a47f72531a4462e56178dfe1ecc56b36'
AND (
token = 'C+h0Zkx0aJMpbASrElqZkvpE+GJHBl7xNAsY8Lpip78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)