UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0wGLcoKsHfCFETi4eSyzXgqbTPT4eIEwzod8hy7khtk='
WHERE
key_id = '9d3781f4c7d8b061f717256bc1bae8b32ecde06abd96512954569f2e212654eb'
AND (
token = '0wGLcoKsHfCFETi4eSyzXgqbTPT4eIEwzod8hy7khtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)