UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7v3yL+wT1GEZo+Jk0SKeHkkguofzXS7xKU7jcIEhfIs='
WHERE
key_id = '6526be8163a2857a994a2b9fae02487d3660c9179e1a7a00f29301055aa0de00'
AND (
token = '7v3yL+wT1GEZo+Jk0SKeHkkguofzXS7xKU7jcIEhfIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)