UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ONOS9TDWNjh47vwqfaAul6lGuSmW4yWqbkKv7X8OHO8='
WHERE
key_id = 'd8185d7b6359ebaabb1302f53fe1446a40853a458d0732044280d6db57f0c4ad'
AND (
token = 'ONOS9TDWNjh47vwqfaAul6lGuSmW4yWqbkKv7X8OHO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)