UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0rztEszNjp7H7WY/N1IqcVO3ECxdR59YlO9/lllDSIs='
WHERE
key_id = '12e1e426a642d6a17a72ca9c7ac135daf2b69b667dad74713636a2efb6a87746'
AND (
token = '0rztEszNjp7H7WY/N1IqcVO3ECxdR59YlO9/lllDSIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)